/*
 Navicat Premium Dump SQL

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80034 (8.0.34)
 Source Host           : 172.19.0.4:3306
 Source Schema         : mybatis

 Target Server Type    : MySQL
 Target Server Version : 80034 (8.0.34)
 File Encoding         : 65001

 Date: 07/07/2024 17:39:19
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for d01_dept_t
-- ----------------------------
DROP TABLE IF EXISTS `d01_dept_t`;
CREATE TABLE `d01_dept_t` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(10) COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='部门表';

-- ----------------------------
-- Records of d01_dept_t
-- ----------------------------
BEGIN;
INSERT INTO `d01_dept_t` (`id`, `name`, `create_time`, `update_time`) VALUES (1, '学工部', '2024-07-06 13:44:47', '2024-07-06 13:44:47');
INSERT INTO `d01_dept_t` (`id`, `name`, `create_time`, `update_time`) VALUES (2, '教研部', '2024-07-06 13:44:47', '2024-07-06 13:44:47');
INSERT INTO `d01_dept_t` (`id`, `name`, `create_time`, `update_time`) VALUES (3, '咨询部', '2024-07-06 13:44:47', '2024-07-06 13:44:47');
INSERT INTO `d01_dept_t` (`id`, `name`, `create_time`, `update_time`) VALUES (4, '就业部', '2024-07-06 13:44:47', '2024-07-06 13:44:47');
INSERT INTO `d01_dept_t` (`id`, `name`, `create_time`, `update_time`) VALUES (5, '人事部', '2024-07-06 13:44:47', '2024-07-06 13:44:47');
COMMIT;

-- ----------------------------
-- Table structure for d01_emp_t
-- ----------------------------
DROP TABLE IF EXISTS `d01_emp_t`;
CREATE TABLE `d01_emp_t` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(20) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名',
  `password` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '123456' COMMENT '密码',
  `salt` char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '随机盐',
  `name` varchar(10) COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名',
  `gender` tinyint unsigned NOT NULL COMMENT '性别, 说明: 1 男, 2 女',
  `image` varchar(300) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '图像',
  `job` tinyint unsigned DEFAULT NULL COMMENT '职位, 说明: 1 班主任,2 讲师, 3 学工主管, 4 教研主管, 5 咨询师',
  `entrydate` date DEFAULT NULL COMMENT '入职时间',
  `dept_id` int unsigned DEFAULT NULL COMMENT '部门ID',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='员工表';

-- ----------------------------
-- Records of d01_emp_t
-- ----------------------------
BEGIN;
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (1, 'jinyong', '747713f42f603632d74b214f7221cb4b', 'gmk2hdpp', '金庸', 1, '1.jpg', 4, '2000-01-01', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (2, 'zhangwuji', 'a95bac30580dc0a572ee23c9fe21fda1', 'waw00tmk', '张无忌', 1, '2.jpg', 2, '2015-01-01', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (3, 'yangxiao', 'b367e5e7c6b3ab9087bf3509601e6d0c', 'ma6w3f9d', '杨逍', 1, '3.jpg', 2, '2008-05-01', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (4, 'weiyixiao', '1b4b1533ae15739951531817337f8e70', 'hkypbcbh', '韦一笑', 1, '4.jpg', 2, '2007-01-01', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (5, 'changyuchun', 'ae24f1782879a07e36f9e82079d08e87', 'px8d1wfc', '常遇春', 1, '5.jpg', 2, '2012-12-05', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (6, 'xiaozhao', '686f484eadf20344b814b8e7e956fce7', 'v3p0zi4p', '小昭', 2, '6.jpg', 3, '2013-09-05', 1, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (7, 'jixiaofu', '823155118d4337b35025bf9d639bb328', '71xb4300', '纪晓芙', 2, '7.jpg', 1, '2005-08-01', 1, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (8, 'zhouzhiruo', '3e582d737af8605056949d736935c9af', 'oojq9ah7', '周芷若', 2, '8.jpg', 1, '2014-11-09', 1, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (9, 'dingminjun', '8a3ca6c3ac682abb0e515d538ebc8c99', 'xc79hz7y', '丁敏君', 2, '9.jpg', 1, '2011-03-11', 1, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (10, 'zhaomin', 'c62c7b98be6fe4d8cfcd3b2d6a0ad726', 'ddt4ppvw', '赵敏', 2, '10.jpg', 1, '2013-09-05', 1, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (11, 'luzhangke', 'f51b1451695978a17359c31f6d3fa9dc', 'jx8l9alr', '鹿杖客', 1, '11.jpg', 5, '2007-02-01', 3, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (12, 'hebiweng', 'c771ce720ea676e613584c5edc6fb441', 'cg2fxce5', '鹤笔翁', 1, '12.jpg', 5, '2008-08-18', 3, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (13, 'fangdongbai', '4da883a1aa5d4242255bb9bbfc76946c', 'n5wtazzu', '方东白', 1, '13.jpg', 5, '2012-11-01', 3, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (14, 'zhangsanfeng', 'efc9b6a0f372a882c5186cc5e7c2198d', 'aku63cbl', '张三丰', 1, '14.jpg', 2, '2002-08-01', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (15, 'yulianzhou', 'e704655731a54ff220e19c232cb30ea9', 'cdem6wwv', '俞莲舟', 1, '15.jpg', 2, '2011-05-01', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (16, 'songyuanqiao', '2d211c15bdcca391b8490cee946ebafc', '0qfal9m0', '宋远桥', 1, '16.jpg', 2, '2007-01-01', 2, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
INSERT INTO `d01_emp_t` (`id`, `username`, `password`, `salt`, `name`, `gender`, `image`, `job`, `entrydate`, `dept_id`, `create_time`, `update_time`) VALUES (17, 'chenyouliang', '8a295d534c1721d548b2647ff77b2fd9', 'hppbsceo', '陈友谅', 1, '17.jpg', NULL, '2015-03-21', NULL, '2024-07-06 13:44:55', '2024-07-06 13:44:55');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名',
  `age` tinyint unsigned DEFAULT NULL COMMENT '年龄',
  `gender` tinyint unsigned DEFAULT NULL COMMENT '性别, 1:男, 2:女',
  `phone` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手机号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户表';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `name`, `age`, `gender`, `phone`) VALUES (1, '白眉鹰王', 55, 1, '18800000000');
INSERT INTO `user` (`id`, `name`, `age`, `gender`, `phone`) VALUES (2, '金毛狮王', 45, 1, '18800000001');
INSERT INTO `user` (`id`, `name`, `age`, `gender`, `phone`) VALUES (3, '青翼蝠王', 38, 1, '18800000002');
INSERT INTO `user` (`id`, `name`, `age`, `gender`, `phone`) VALUES (4, '紫衫龙王', 42, 2, '18800000003');
INSERT INTO `user` (`id`, `name`, `age`, `gender`, `phone`) VALUES (5, '光明左使', 37, 1, '18800000004');
INSERT INTO `user` (`id`, `name`, `age`, `gender`, `phone`) VALUES (6, '光明右使', 48, 1, '18800000005');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
